how to find duplicates in Excel: identify, highlight count, filter, and more

by Svetlana Cheusheva | updated on June 17, 2019 108 Comments

The tutorial explains how to search for duplicates in Excel. You will learn a few formulas to identify duplicate values or find duplicate rows with or without first occurrences. You will also learn how to count instances of each duplicate record individually and find the total number of dupes in a column, how to filter out duplicates, and more.

While working with a large Excel worksheet or consolidating several small spreadsheets into a bigger one, you may find lots of duplicate rows in it. In one of our previous tutorials, we discussed various ways to compare two tables or columns for duplicates.

And today, I'd like to share a few quick and effective methods to identify duplicates in a single list. These solutions work in all versions of Excel 2016, Excel 2013, Excel 2010 and lower.

• How to identify duplicates in Excel
  • Check for duplicates with 1st occurrences
  • Search for duplicates without 1st occurrences
  • How to find case-sensitive duplicates in Excel

• How to find duplicate rows in Excel
• How to count duplicates in Excel
• How to filter duplicates in Excel
• Other ways to deal with duplicates (highlight, remove, select, copy or move)
• Duplicate Remover for Excel - fast and formula free way to locate duplicates

How to identify duplicates in Excel